SUPPORT / SAMPLES & SAS NOTES
Problem Note 47796: Status in the Analysis Results table might be "NA" after executing Holdout Forecast Analysis
 |  |  |  |
Beginning in SAS® Merchandise Solutions Configuration Workbench 5.2, the status in the Analysis Results table might be "NA" after executing Holdout Forecast Analysis. A status of "NA" indicates that a model group in the FA_MODEL_GROUP table has a SEASON value that does not match the SCENARIO_TYPE value for an enabled scenario. However, the SAS Merchandise Solutions Configuration Workbench attempts to incorrectly calculate a score for this scenario and the following exception is generated in the configwb.log:
com.sas.solutions.di.tools.server.services.api.CwException: com.sas.solutions.di.commons.util.ExpressionException: No values are defined for the parameters sales_weighted_mape, median_pe, sales_weighted_mean_pe, inv_weighted_mape, revenue_weighted_mean_pe, inv_weighted_mean_pe, revenue_weighted_mape
at com.sas.solutions.di.tools.server.services.api.CwException.generateException(CwException.java:230)
at com.sas.solutions.di.tools.client.fa.util.FAScoreCalculationUtil.checkAndCalculateStatusScores(FAScoreCalculationUtil.java:100)
at com.sas.solutions.di.tools.client.proxies.FAHoldoutServiceProxy.getScenarioStatusResults(FAHoldoutServiceProxy.java:197)
at com.sas.solutions.di.tools.client.fa.analysisresult.FAAnalysisResultController.loadFAScenarioStatus(FAAnalysisResultController.java:78)
at com.sas.solutions.di.tools.client.fa.analysisresult.FAAnalysisResultController.load(FAAnalysisResultController.java:100)
at com.sas.solutions.di.tools.client.fa.common.ui.folios.AbstractFolio$1.execute(AbstractFolio.java:85)
at com.sas.solutions.di.commons.jobs.AbstractJob.internalExecute(AbstractJob.java:454)
at com.sas.solutions.di.commons.jobs.AbstractJob.run(AbstractJob.java:420)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: com.sas.solutions.di.commons.util.ExpressionException: No values are defined for the parameters sales_weighted_mape, median_pe, sales_weighted_mean_pe, inv_weighted_mape, revenue_weighted_mean_pe, inv_weighted_mean_pe, revenue_weighted_mape
at com.sas.solutions.di.commons.util.ExpressionEvaluation.validateParmsForEvaluation(ExpressionEvaluation.java:260)
at com.sas.solutions.di.commons.util.ExpressionEvaluation.evaluate(ExpressionEvaluation.java:231)
at com.sas.solutions.di.tools.client.fa.util.FAScoreCalculationUtil.checkAndCalculateStatusScores(FAScoreCalculationUtil.java:97)
... 7 more
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Promotion Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Regular Price Optimization | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||
| SAS System | SAS Retail Forecasting | Microsoft® Windows® for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 |
| Linux for x64 | 5.2 | 5.2_M1 | 9.3 TS1M0 | 9.3 TS1M0 | ||